﻿/*Considered calling this [Execution] but I wanted to distinguish 
between a Catalog Execution and a thing that can be restarted*/
CREATE TABLE [RestartFramework].[ETLJob] 
(
	[ETLJobId]				SMALLINT			NOT NULL
,	[ETLJobName]			SYSNAME				NOT NULL
,	[ETLJobCreatedDate]		DATETIMEOFFSET(7)	NOT NULL DEFAULT SYSDATETIME()
,	CONSTRAINT [PK_RestartFrameworkETLJob] PRIMARY KEY ([ETLJobId]) 
,	CONSTRAINT [UK_RestartFrameworkETLJob_ETLJobName] UNIQUE ([ETLJobName])
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'A friendly unique identifier for this ETLJob',
    @level0type = N'SCHEMA',
    @level0name = N'RestartFramework',
    @level1type = N'TABLE',
    @level1name = N'ETLJob',
    @level2type = N'COLUMN',
    @level2name = N'ETLJobName'